Acceptable Values

The Acceptable Values quality control (QC Quality Control) check identifies features containing values outside of a defined list. Any records with values that do not match the acceptable values list will create a fallout. For example, if there is one acceptable value for the service urn in an emergency services boundary layer, that value can be provided and the user is notified if any values in that field do not contain that specific value.

To run this check, a feature class or table is required.

Configurations for QC check parameters contain filters to prevent selecting incompatible field types.

This QC check can be configured to run on any field or column. The list of acceptable values is configurable for easy customization.

The following parameters can be specifically configured for the Acceptable Values QC check.

  • Run On: Non-configurable. This QC check inspects the target dataset.

  • Severity: Sets the importance level of this QC check’s fallouts. Critical fallouts prevent export package outputs but will still provide fallouts.

  • Layer or Table Name: The name of the layer or table this QC check should inspect.

  • Reporting Unique ID: A unique identifier in the layer or table that can be used to uniquely identify a singular feature.

  • Field Name or Column Name: The name of the field or column this QC check should inspect.

  • Acceptable Values List: A list of all acceptable values this layer or table may contain.

  • Case Sensitivity: Select Match Case to enable and maintain the integrity of upper or lower case text in your data. See Case Sensitivity.

  • Additional Acceptable Values: Select the additional value(s) you want to add to the acceptable values list. See Additional Acceptable Values.

The following information is included for this QC check's fallout output.

  • QC check name
  • Description of the QC check
  • Unique ID
  • Feature class where the fallout appears
  • Extended information providing more details about the fallout

The example below shows a possible error message you may receive when a record fails the Acceptable Values QC check. The extended information provides the layer/table name and the layer's field/column field name where the value(s) fall outside the defined list; the value that triggered the fallout is also provided.

Here is an image of messages you may receive for the Acceptable Values QC check.